<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
    <title>MydbQA - Analyze report</title>
    <link href="style/main.css" rel="stylesheet" type="text/css" />
    <link href="style/highlight/styles/default.css" rel="stylesheet" type="text/css" />
    <TMPL_UNLESS nohighlight>
        <script type="text/javascript" src="style/highlight/highlight.js"></script>
        <script type="text/javascript">initHighlightingOnLoad();</script>
    </TMPL_UNLESS>
</head>
<body>
    <br />
    <div id="extract">
        <h1>Describe tables</h1><br/>
        <TMPL_LOOP describe>
            <div class="box mt10">
                <p>Table: <b><TMPL_VAR describe_t></b></p>
                <table>
                    <tr class="header">
                        <td style="width: 25%">Field</td>
                        <td style="width: 20%">Type</td>
                        <td style="width: 15%">Default</td>
                        <td style="width: 10%">Null</td>
                        <td style="width: 15%">Key</td>
                        <td style="width: 15%">Extra</td>
                    </tr>
                    <TMPL_LOOP describe_t_res>
                    <tr>
                        <td><TMPL_VAR Field></td>
                        <td><TMPL_VAR Type></td>
                        <td><TMPL_VAR Default></td>
                        <td><TMPL_VAR Null></td>
                        <td><TMPL_VAR Key></td>
                        <td><TMPL_VAR Extra></td>
                    </tr>
                    </TMPL_LOOP>
                </table>
            </div>
        </TMPL_LOOP>
        <br /><h1>Extracting queries</h1><br />
        <TMPL_LOOP extract>
            <div class="box mt10">
                <pre><code class="sql"><TMPL_VAR extract_q></code></pre>
                <div class="line">&nbsp;</div>
                <TMPL_IF extract_c_sql>
                    <p>SQL: <em><TMPL_VAR extract_c_sql></em></p>
                    <p>Result: <b><TMPL_VAR extract_c_res> rows</b></p>
                </TMPL_IF>
                <TMPL_IF extract_g_sql>
                    <p>SQL: <em><TMPL_VAR extract_g_sql></em></p>
                    <p>Min/Avg/Max: <TMPL_VAR extract_g_res> rows</p>
                </TMPL_IF>
            </div>
        </TMPL_LOOP>
    </div>
    <br /><br/>
</body>
</html>